﻿using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using Windows.Foundation;
using Windows.Foundation.Collections;
using Windows.UI.Xaml;
using Windows.UI.Xaml.Controls;
using Windows.UI.Xaml.Controls.Primitives;
using Windows.UI.Xaml.Data;
using Windows.UI.Xaml.Input;
using Windows.UI.Xaml.Media;
using Windows.UI.Xaml.Navigation;
using SQLite;

// The Blank Page item template is documented at http://go.microsoft.com/fwlink/?LinkId=234238

namespace SQLite_Demo
{
    using System.Collections.ObjectModel;

    using SQLite_Demo.Models;

    /// <summary>
    /// An empty page that can be used on its own or navigated to within a Frame.
    /// </summary>
    public sealed partial class MainPage : Page
    {
        private string dbPath;

        public MainPage()
        {
            this.InitializeComponent();
            this.Loaded += (s, e) => CustomerList.ItemsSource = this.GetCustomers();
        }

        /// <summary>
        /// Invoked when this page is about to be displayed in a Frame.
        /// </summary>
        /// <param name="e">Event data that describes how this page was reached.  The Parameter
        /// property is typically used to configure the page.</param>
        protected override void OnNavigatedTo(NavigationEventArgs e)
        {
        }

        public ObservableCollection<Customer> GetCustomers()
        {
            var customers = new ObservableCollection<Customer>();
            using (var db = new SQLiteConnection(App.DBPath))
            {
                var query = db.Table<Customer>().OrderBy(c => c.Name);
                foreach (var customer in query)
                {
                    customers.Add(customer);
                }
            }
            return customers;
        }

    }
}
